CREATE TABLE IF NOT EXISTS `logs` (
  `id` int(11) NOT NULL auto_increment,
  `selectedpage` tinytext collate utf8_unicode_ci,
  `frompage` tinytext collate utf8_unicode_ci,
  `browser` tinytext collate utf8_unicode_ci,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ip` varchar(15) collate utf8_unicode_ci default NULL,
  `url` tinytext collate utf8_unicode_ci,
  `username` varchar(50) collate utf8_unicode_ci default NULL,
  `prams` text collate utf8_unicode_ci,
  `host` varchar(255) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=50 ;
